SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443341 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443341 [ RunTime:0.002572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936894,481723,388145,424742,84235,67518,446450,535340,1035037,708756,263870,389106,637111,305554,880402,599928,879295,702020,658605,620165,119091,433652,972535,904788,619531,60655,205135,394385,974856,1019335,84241,1011562,638728,879428,155437,834377,915090,470197,786876,64144,805434,106741,185024,276413,585191,778257,156012,349250,258494,126116,351355,383936,461334,731622,577388,457305,569370,618264,236118,148344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]