SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041058 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041058 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875683,68803,190006,743187,982117,744486,339868,63490,139261,859000,1030364,823562,846028,445935,786171,569182,39312,748941,2265,207595,292949,346800,810378,1042754,185191,409846,854361,966787,37938,1032625,344986,990983,898320,549986,743034,484948,971077,750915,311950,1017713,630496,1012813,88422,960353,105249,304431,689067,816164,531762,509629,1006375,943528,495231,683626,90653,68159,469634,824559,388746,283939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]