SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023535 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023535 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10462,311916,155708,605078,304808,875987,649148,486317,641623,707593,704836,1036052,460487,527836,258921,661532,492072,483084,105158,791242,279102,762283,993175,94911,843933,705806,907997,497396,522854,596006,860776,216828,804363,894698,405875,463064,399870,637274,1029881,581794,768331,431266,245517,349803,424562,163797,984440,546872,471428,393373,791141,1024040,1001254,534206,159202,801319,969578,349585,172071,241175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]