SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431963 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431963 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114347,684894,922643,781649,754514,78244,503525,95139,333245,212053,365660,621527,993940,500994,768609,422827,400161,500188,825763,508724,859145,988564,668793,44058,541916,880452,311968,485598,823140,541995,563350,11130,200371,61943,313597,982618,307152,616929,468459,60657,42969,808537,191668,676200,261135,907990,59003,884453,135419,600386,328788,120157,148203,156367,245745,336455,93103,1021929,467264,772781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000818s ]