SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508217 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508217 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95336,791848,284242,908042,418413,738949,441222,200962,1020440,89253,392106,528171,400259,392838,920781,184786,364949,810908,1023896,876785,896091,832733,876686,15973,635580,164581,3634,499355,899251,810554,530184,538855,831542,1021244,3336,4509,628916,104454,505665,613072,644207,481840,164016,824571,476328,588786,302795,690124,98617,831352,144036,493010,252296,858997,1019631,411553,119591,304951,636896,484554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001334s ]