SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534091 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534091 [ RunTime:0.002320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567785,572372,815688,946427,1019184,155801,451219,683199,568743,715716,481471,353265,342410,212744,178308,337556,305601,956403,414311,10910,934238,97087,496196,1003700,539892,915184,674712,979949,916679,690907,388103,953949,542757,426465,630177,1024919,656079,797882,741084,768427,212667,717153,179502,679112,874812,636264,490268,639769,876772,950859,385516,832549,825131,562029,149015,250854,402875,732119,1013787,710008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]