SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529170 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529170 [ RunTime:0.002394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177618,877620,1027156,366887,705014,465019,320712,108117,293903,935746,484407,277931,571707,116689,123241,288892,833424,419085,493553,366162,864356,539138,220969,171507,1031004,339015,243808,199553,938826,622042,241557,365216,501479,500913,965422,171990,638189,873250,744130,57711,1037943,895385,48856,464239,974466,963060,156118,986000,35993,20582,544065,420627,573607,889719,944999,263191,955967,377519,304865,792000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]