SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506645 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506645 [ RunTime:0.002327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846989,504585,1021692,47493,428652,252826,822948,822899,1006852,891815,8759,810881,434390,766192,18928,701671,1022856,569005,336171,869961,595453,109015,32263,735360,316104,450882,615317,305912,247101,306764,650285,253415,163260,1030901,736144,1007796,56431,7459,1028754,900879,387277,638657,985042,799609,844323,877250,679253,872240,615678,253072,366839,75698,397684,577563,999869,977343,1020600,150031,1013633,639475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506645 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506645 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]