SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026156 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026156 [ RunTime:0.002218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520279,910913,325112,1009904,407579,705395,203863,760568,703501,283177,212958,611409,614665,149254,482802,628519,102658,179215,9306,30608,386798,52997,144192,817224,646669,684183,1008323,324679,692592,486854,42993,256132,596305,905944,776048,41124,252056,936780,158474,204496,1025688,933157,863718,739531,485252,214390,822998,266539,438626,16565,82212,171651,430692,245776,761837,636985,26745,149941,345255,1040230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]