SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425015 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425015 [ RunTime:0.002235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146755,15474,800391,942127,48888,718829,67803,791427,660266,687367,542979,918050,366639,460107,705811,720437,145281,744974,196590,392305,399642,125250,462586,977675,508229,713599,188974,547364,91020,822974,914083,757369,154819,591805,618404,1030644,43084,72922,615740,586402,310920,943054,80724,184957,108520,243051,165083,242535,420655,571023,322666,974597,825474,1010973,739677,939898,709494,639138,401681,612820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001801s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]