SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501206 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501206 [ RunTime:0.004155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626927,573012,948306,796650,61554,254364,399469,451204,860830,336323,1001563,441217,277671,425485,944831,436180,1039852,340525,979015,729565,54918,144720,957758,628134,711426,374942,28548,554485,28810,245740,623279,47406,296863,519892,35461,1028279,780678,128409,151707,876646,569641,308948,211012,661096,1034160,796787,619110,103228,133115,906615,184343,278293,839493,756006,735797,837755,1029013,221333,452569,122990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]