SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022259 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022259 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441769,386167,927596,683324,727952,525281,140070,754553,1033420,332674,198988,973151,410277,520613,710391,536521,860014,592916,616559,164022,280090,1015580,717370,353662,54819,772712,253025,576691,229114,906320,810280,273330,898500,356541,737395,684109,389197,656248,642418,365554,157023,245671,965267,174176,950473,511430,797087,256707,589079,205492,251108,290243,341761,680846,338228,236183,583396,94860,1012151,665431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022259 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022259 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]