SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405475 LIMIT 1 [ RunTime:0.004371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405475 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622596,666995,10880,828563,492853,419131,687861,27466,639467,16992,132607,1031495,252781,332729,702751,903861,232543,489316,90369,155415,137333,891356,104588,442554,724437,76124,103593,671643,515509,348200,538907,360683,293073,9238,147339,889503,521538,970089,169968,778810,410803,669903,945050,102442,71361,434573,620796,989319,870484,323791,135967,1017612,629581,886430,630599,285724,552691,144100,156715,252756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]