SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401090 LIMIT 1 [ RunTime:0.000652s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401090 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (965399,263252,907653,916140,557667,657616,237305,827087,873242,377638,486603,90497,569825,976369,993724,128,427957,77035,865508,148208,664568,275797,131547,73060,787828,641906,978453,864715,898997,773326,30740,767793,809885,895120,72514,994943,890569,532067,207092,436790,424499,626444,1012099,336369,86824,968505,599681,1006032,90722,67557,51492,936234,124868,941324,981681,906168,1030661,787134,673165,610592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]