SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106841 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106841 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739056,216720,629832,334296,774751,146534,419658,438430,47779,205985,568766,563221,913593,454656,430220,550093,739479,555856,118560,268371,648199,840845,7630,38886,91286,755015,627725,914970,537241,420146,482481,245851,408996,827676,38804,139263,988114,440801,401157,646956,215300,373975,731969,817987,278482,447317,468152,521603,498701,889953,991730,400842,382030,653124,606472,556447,171920,152747,270886,999062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]