SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501955 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501955 [ RunTime:0.002547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915209,1025314,996017,367069,856400,233771,1014811,526034,568405,248225,967256,532998,286817,131836,179873,35346,637356,409133,1042951,181666,67748,922397,1028055,332126,852171,906446,768138,904324,300365,662453,901031,171880,929654,276916,527034,308330,266651,961172,639887,744460,340885,698059,811744,1024577,643187,557934,1016576,603687,633983,517354,955357,167494,804769,324338,109280,243299,809028,923450,463227,398662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501955 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501955 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000824s ]