SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512027 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512027 [ RunTime:0.009692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450682,436733,490462,796447,377844,327413,410621,646963,84096,70267,242942,1012165,286754,110704,225884,48236,912610,696417,496631,851877,649230,435548,775558,701823,287171,363898,375261,113236,470818,727758,123974,324128,1020743,431497,280199,162086,374731,534429,98519,576801,232135,974730,1023824,126775,953424,766312,63775,507797,648297,766926,524321,609337,298945,313434,798174,39304,754059,832772,78677,29707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]