SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 9813 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 9813 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416974,287976,332964,34639,148249,729664,229746,486930,319207,1042791,437015,105269,187063,416743,230530,489244,386498,960182,842165,321166,278664,968261,865981,911632,679564,323024,267866,820681,784175,100573,661042,797737,980235,134025,868130,970680,832610,872889,581674,847679,8753,555289,3822,1035346,562799,531420,803762,837138,650639,835145,856629,985117,117015,955134,480736,776040,902904,19610,1024751,681077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 9813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 9813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]