SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200390 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200390 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367156,131607,279761,189877,497520,777413,936144,147784,937544,78632,551260,251641,380560,1027981,925580,403233,382547,839074,1003448,186972,12998,190116,170708,969860,123677,546186,255232,353673,623757,364107,635117,402720,611401,1033716,342254,417927,41332,303875,956389,102236,376942,865747,432655,524188,847793,11794,194774,1036012,558300,980714,271869,845213,557397,466326,812305,108799,299357,34639,355042,756854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]