SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513458 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513458 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908290,854745,359095,712113,347703,405827,334913,708703,950841,1441,884471,538868,172463,636690,670543,696888,462655,200735,555331,892748,297477,44298,471422,893552,930264,782829,533667,823538,977726,860073,45350,479271,292437,543163,230456,183406,254107,259574,139137,597282,16834,873839,313459,174491,951960,564282,436897,913214,670974,629834,497580,597661,972115,459486,525354,1007089,539348,807923,104137,382455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]