SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001953s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598078 LIMIT 1 [ RunTime:0.001781s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598078 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237017,798203,369115,453700,521976,504703,477340,176849,320159,902707,22537,1026085,714892,498897,762165,700393,204082,185709,357754,238168,353056,189314,717983,934622,838965,142589,88087,242951,24925,551054,951825,34750,663742,287420,334745,770469,668565,387962,504773,330670,1035288,272523,195095,132490,496373,910091,280568,165746,839214,1047978,51225,684351,845742,500016,506375,917316,771724,195674,124368,281441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000873s ]