SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002604s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403185 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403185 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987165,794002,420468,565553,964302,963687,1298,585740,928260,944234,265842,6060,69121,504002,483910,792046,973174,25364,340591,533045,629648,1035766,800877,248333,758973,287035,258294,791426,909950,462725,574650,451957,21515,112702,445789,826025,850358,476453,596840,6183,435955,376468,872821,978967,490384,468482,1036162,939790,202857,319842,361367,896976,1003851,375609,425117,94380,894353,606405,204974,120812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001775s ]