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` = 596805 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596805 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383495,182209,462965,927459,185657,848764,540362,414807,1022176,219660,868705,485725,791000,391577,439481,187073,347134,155290,556082,212918,113716,331820,797536,296684,816897,313919,845353,57000,487034,746259,386704,844934,1037574,831830,536152,328114,997688,469734,97917,80452,496311,338459,630912,947314,45889,850546,289558,182464,102674,619638,672136,934233,1047008,637604,58780,329524,33259,143864,766260,540763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]