SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482128 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482128 [ RunTime:0.003142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37750,26382,31497,1023074,922596,579814,215558,541421,838883,9609,950260,997022,881798,802282,259700,811124,85777,256314,942619,1043497,256876,878527,103645,756307,338482,579841,276436,295376,16341,1020092,685753,553104,529497,245508,221975,636273,227541,957004,378105,822707,602748,371842,338387,511859,803360,292586,33375,918697,954795,407126,974788,289559,835403,554438,941516,494017,325863,222564,417699,819877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]