SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487929 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487929 [ RunTime:0.003209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47558,870380,102935,223739,530012,538741,429004,742277,997771,242104,1044315,213137,231217,910064,406163,901841,850715,503205,765080,314078,190273,82433,228478,741496,130907,939722,425186,581835,754396,694534,502886,515104,128613,971836,944936,240581,388585,625623,746367,594711,51936,905755,16814,81371,459375,927352,250032,681160,318311,18273,118456,762001,370182,930887,390302,60435,629632,987978,776566,86809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]