SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40781 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40781 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424047,174905,244264,928317,584524,147278,635706,944934,595734,693590,770257,176428,665561,84503,1040511,581154,375751,824815,419662,322877,937791,774814,175358,1023314,689055,791478,141039,625284,102283,221654,416962,764171,667074,557528,206040,1002452,924753,232514,689946,975812,867,1042214,746106,549585,210629,371459,595653,608323,675628,262295,842460,726625,161905,622006,776964,811096,727438,163590,396338,281273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]