SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45093 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45093 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215874,544828,112431,267048,778076,553233,702196,570424,459628,283847,829817,771070,261986,69234,1004026,709143,665554,974910,296939,617111,979294,45452,197849,436302,350463,325796,807954,637541,190371,540176,272673,515753,315972,511227,239177,863631,652899,549672,407205,851424,296389,871197,577014,30249,405183,883081,801655,108913,1017892,209225,153129,235876,193671,301375,800952,118503,149982,83244,260422,602542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]