SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001634s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55872 LIMIT 1 [ RunTime:0.001741s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55872 [ RunTime:0.005801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902900,674930,686958,423949,252983,669997,998807,587272,121468,911915,932538,404515,272880,902327,346135,205687,1037290,931371,497299,670126,1028133,100972,75689,734319,393284,240286,544529,776284,139017,805946,331250,474829,237683,798871,465538,694780,643477,1044281,572493,162600,749469,930036,516533,522520,904108,1030253,653155,1016731,180704,211597,324042,857135,891640,848040,302615,390936,159347,159830,244845,803657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55872 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55872 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000743s ]