SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403055 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403055 [ RunTime:0.002457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514511,443001,86303,216349,7100,816591,191587,831371,474760,418367,473668,577826,923178,619373,46098,869592,1000060,465176,898813,15410,710572,689143,245189,948801,523551,812008,776265,350764,633355,466815,388090,43747,725392,734049,592691,496549,244352,121696,565442,543047,619605,852810,869243,406615,138847,694117,416276,509256,1023332,983606,332137,200876,42409,613391,637045,903852,304285,200214,337079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403055 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403055 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]