SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195441 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195441 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66074,396503,543766,570691,226539,529052,84927,613520,385388,167038,288201,941444,800146,395918,959666,1038267,178476,543976,218905,367365,538405,557796,629785,334174,1039547,361786,336180,521663,675781,811682,957651,76560,991863,664528,522709,737867,645532,359193,977777,518456,123974,784489,484436,728317,602627,203384,476790,599284,93949,628617,974637,456560,417726,411172,930036,22957,343501,295395,524490,423067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]