SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468158 LIMIT 1 [ RunTime:0.000562s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468158 [ RunTime:0.001466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008619,26700,18874,159454,431016,974753,868692,91288,534721,941154,307193,689954,122398,656018,712503,532061,256757,534548,959064,562595,396666,687169,340459,155307,1047360,378342,847402,526225,229429,668642,625907,1030644,1011319,1033697,55395,200807,400001,727921,916464,1029041,279906,804473,37394,883209,241466,243893,649778,689900,129834,1025479,364753,969019,216333,475513,864558,778371,292171,598235,18864,461030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]