SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291543 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291543 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960410,482405,497995,295456,604932,417394,964213,63357,742148,352385,631787,210840,420986,474499,122475,876403,929393,167419,476061,636156,486476,468692,639398,941794,880898,868467,976333,52188,1041352,197282,516492,29208,13872,74507,579615,635444,303579,935867,860031,391359,905921,444719,989259,531796,418071,455006,147023,379174,769626,451446,580476,369578,12358,986444,159020,752865,518306,625376,937875,966616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]