SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404694 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404694 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19851,832240,63733,380437,863803,760321,778589,914338,788708,493881,856359,87962,489594,931735,153482,663168,233726,132651,473782,830912,645396,211369,422615,121770,67198,792476,346788,418123,759892,101532,794297,512595,67736,681542,228337,46167,523484,346224,846518,81844,487153,833881,332659,426182,955470,870141,122312,504381,771379,761706,180908,536242,529936,723882,635941,256308,907955,1002471,447179,1035219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]