SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 178180 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 178180 [ RunTime:0.002199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843256,503181,724787,87929,809988,521344,523914,1040810,243069,271267,835371,12409,946610,128298,1042491,254672,124023,487139,364902,441562,491414,249785,779199,651419,678736,809130,46746,842020,418550,948608,236543,945305,210096,483582,535394,802076,287074,10964,453912,487470,2587,116307,440622,122020,883495,308655,555783,551607,1032939,759046,59880,222043,106509,839946,44296,724395,889966,415149,345974,332303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 178180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002674s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 178180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.008793s ]