SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415936 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415936 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102559,489140,350673,60994,346636,518861,61326,531565,887594,37769,976748,960002,304717,291725,485567,214365,988371,738095,461304,1046605,324008,159561,882647,993638,190237,940787,68442,636931,804363,546446,580431,876864,300145,538846,606354,991071,738462,508894,152576,720043,488775,476827,654021,398112,962385,982499,1034667,27841,179487,55245,287513,422315,597047,138927,48872,991097,341858,817956,193205,497070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]