SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 388196 LIMIT 1 [ RunTime:0.001421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388196 [ RunTime:0.002598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176672,305710,510714,983089,882777,939450,267141,446352,917903,580508,694017,79455,568648,972099,386032,176499,405687,108087,949966,469185,147330,53178,128364,227690,786159,894075,734307,66549,775982,843318,102065,373294,745576,1042385,856842,830763,1040746,819904,118921,330338,720708,284747,104195,32208,1002726,309083,781203,151308,366715,719860,395539,414868,206669,461803,373293,229117,225465,109089,259664,103812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]