SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544269 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544269 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580528,696594,679567,142128,904448,867688,788155,277714,385036,155541,883435,320922,1038267,5026,232961,999346,444688,409383,536916,373115,1010596,614399,320041,339375,983822,710233,513106,405924,827283,648834,418576,41191,585371,621200,819179,593856,235910,417600,685041,946039,634808,504803,534109,56816,874942,493356,105450,254454,573698,1015869,257819,315290,982192,711483,905484,323234,686194,145256,230563,359045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544269 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544269 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]