SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005740 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005740 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346505,801674,62508,394603,712441,458073,820223,344709,752399,949575,151996,568116,126120,673992,194901,119284,510003,1037199,500220,891975,172524,1001485,755979,707967,356668,194373,584396,169623,937710,364051,194641,423653,215443,278678,294506,258397,418833,496448,540007,790708,147839,492438,848050,850328,326784,676596,910528,483152,300438,834352,128697,93937,245994,54125,738109,391377,1020798,39111,385617,486788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001664s ]