SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473317 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473317 [ RunTime:0.002506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194420,531175,467921,479801,1010287,527161,355095,650992,611757,20670,722387,59773,570310,891768,316851,601760,749833,478156,238411,845689,867050,528103,962647,328193,559809,842390,903837,870185,311237,806167,678557,317735,844989,779633,899804,463458,609031,540676,1019334,53899,732061,72544,639641,1004627,360074,199629,440213,495086,117574,971974,986487,848181,970904,350878,538845,579438,382823,176111,993575,51205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]