SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001981s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 652180 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 652180 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277564,332649,792426,898213,71762,593945,340109,80602,253559,214258,1259,339532,897869,456300,100127,606589,988795,844493,1037895,935907,273590,673311,580868,1027412,209750,169519,838690,917986,822065,120227,146103,159505,590445,320547,183846,412986,46742,893922,118648,804157,296270,257484,709735,388077,152907,334905,754790,479974,795400,138855,839348,180750,94611,762310,653359,721364,819050,454759,991397,25827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 652180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 652180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]