SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 321022 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 321022 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447453,92074,618466,1042454,648201,241950,513602,80976,741472,679008,344477,834192,130113,10758,148482,461270,962993,166743,504246,851032,317139,955041,124503,390147,181252,509419,15454,848391,599383,870675,689838,793368,155298,932394,662777,530512,122103,416104,382923,356549,755877,303202,37105,608549,1037939,946702,900975,467429,867294,526877,699577,342430,890000,647417,201865,912670,235603,961730,192713,822795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 321022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 321022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]