SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542458 LIMIT 1 [ RunTime:0.000803s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542458 [ RunTime:0.006515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568334,709161,947314,81200,417322,110464,909404,1002021,270599,378446,199780,1013177,493074,893779,110701,1040487,71746,483429,885966,955561,300379,791790,973107,809847,418265,114000,882815,247927,824123,483572,109889,701738,858013,463246,264303,142265,1039358,248127,472399,500973,1029438,656165,617148,465462,493158,47564,990098,337977,522622,265625,512068,640170,12631,481447,804897,951933,948156,304815,298461,202719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]