SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154143 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154143 [ RunTime:0.002629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52613,171517,610462,677422,577036,18935,313145,299017,139317,587394,66938,206922,903343,190778,5401,1045021,3118,563060,132097,137914,529648,683435,799401,993474,921978,484591,708610,763552,227675,676596,236576,70817,258683,520361,591072,238975,199050,108886,67267,90779,81573,92165,680192,285341,110808,794920,465886,697026,133670,440714,494885,477981,275267,376991,680069,898059,407480,93907,1004124,660580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]