SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53436 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53436 [ RunTime:0.003008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89638,706719,385151,746109,992911,784042,413760,868304,1045809,1043807,1033456,318441,350765,345718,257401,960559,584439,241529,128953,325069,203279,802770,977670,625158,707155,184292,390727,19030,439577,660147,1047890,438116,1018695,251101,952842,249248,1018273,351570,723535,1028352,835760,326461,494597,975250,631431,488302,188690,870657,32859,1015961,887076,279070,1021749,713560,740449,742803,560721,281619,910209,42798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]