SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421936 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421936 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781802,520807,866451,821296,957818,179411,506275,675155,680381,815830,757191,157159,704853,269798,263214,262585,490607,379758,603360,753750,879229,211510,265589,690351,892093,1008372,716782,683648,545688,224083,666876,65814,1035450,761126,671304,757541,243368,269073,1031940,576995,309598,33492,344066,907255,472178,643939,928401,13866,768209,783078,114106,632923,349656,128680,866005,206202,552953,414628,164188,507234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]