SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287526 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287526 [ RunTime:0.002114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118692,144858,930510,45768,800736,917380,885690,326502,693605,898975,114644,430436,831414,484613,393214,145096,336285,16475,837047,532093,432351,250632,235436,110122,210970,263995,77617,1037498,55480,1018473,441870,688500,948925,118829,234953,406390,817995,407812,360224,770434,709660,204480,947084,590071,759978,668483,1022167,550290,547140,534207,195890,258884,227327,247850,453164,677752,318714,298867,128301,216199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]