SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101516 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101516 [ RunTime:0.002510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679252,158868,530532,949038,231913,867977,670029,273913,697764,843585,660124,909605,369075,588815,506297,740601,723050,648378,139416,257133,955268,215704,16332,185172,931752,972666,736653,317739,868525,592258,514908,792354,759591,411056,331202,685654,530013,744871,769671,94544,682490,772578,952793,713892,658795,819913,434527,807768,1014755,571380,839793,579373,248566,722109,953814,186973,44557,149377,901199,246184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]