SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029542 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029542 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722720,514752,1027099,701523,852741,945038,614670,132297,832619,668840,950438,862693,610501,909882,227145,186633,851285,309997,145851,372934,723130,411501,481373,263928,254124,361433,201226,245586,117729,427997,781902,484146,392747,809626,243503,254575,54840,550646,587335,888250,751852,225156,406817,652805,376106,318973,814994,853636,932666,224818,170044,625187,531960,750332,902284,564295,544092,995124,299905,83704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000909s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]