SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002830s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530534 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530534 [ RunTime:0.006180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041871,441648,98612,915556,164018,791175,484592,560882,785004,818743,245298,517635,425262,657822,729692,935168,909533,566482,754067,15499,178288,301563,367213,553552,473804,924720,537344,110092,647394,817464,624014,63426,967654,541916,489466,610025,852435,283162,804016,170752,118838,800250,206137,166426,449788,570691,882042,743245,222027,29572,307111,231678,148630,921364,507260,101347,514645,31362,304267,778640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002791s ]