SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40964 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40964 [ RunTime:0.002471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882734,477986,523893,320147,232378,160027,865037,656651,892037,346405,677509,563496,880129,284120,1045912,203411,916684,467017,233016,888411,849272,705036,766153,104063,404079,749306,52309,262839,8707,102437,271606,976328,1046194,474064,134358,856822,748110,140443,535009,127563,930610,102422,134947,991509,701626,370903,85018,423402,1019790,283947,399604,64661,1041986,384191,824065,740568,1005010,238205,473930,463426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000814s ]