SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407675 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407675 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187299,672021,685857,707481,936170,569266,233966,894993,356705,758056,282264,973130,398013,859784,841034,151547,459417,301500,475078,39879,1028352,381176,65271,337170,546684,943900,263039,951175,777511,557291,495997,448948,634857,666352,169894,1020626,780641,910561,203750,158012,680509,405039,223890,99958,84035,33443,218287,868532,24621,325339,466421,779089,259697,878978,1046241,95394,257197,152992,877116,624849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407675 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407675 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]