SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410317 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410317 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335578,979649,794463,461672,442787,636635,1000898,780467,661161,861126,624217,985463,843984,411502,145826,202706,495345,431666,557864,200814,668064,335621,111445,1046340,499218,1042868,88380,532617,628699,286392,1028362,996285,198155,698635,778936,327265,239994,331027,536336,522030,779856,878889,315078,361950,702034,642166,507744,528680,450209,241038,268814,806870,384311,214900,669657,722547,171690,756243,487005,574045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001467s ]