SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544039 LIMIT 1 [ RunTime:0.003021s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544039 [ RunTime:0.002771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642456,620511,364257,136629,635847,958139,59310,80301,954443,823264,249152,158201,43554,250083,422039,655888,913085,694489,1037405,1041540,929276,889425,952211,577586,204242,527859,762251,238852,475408,190171,391939,395003,69160,960561,402693,678651,294621,1017508,937805,802107,561436,85108,824730,999628,1033713,614820,134812,713262,654403,305546,621967,260417,754081,481855,564098,569846,659313,46759,398029,371444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003017s ]