SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418008 LIMIT 1 [ RunTime:0.000722s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418008 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449786,393363,1036977,278681,919747,40581,250393,890222,673134,927013,916164,81930,930352,37894,576421,371949,762532,847348,7448,229267,543466,630176,99237,903501,135790,214671,1037128,19841,358106,33966,539068,247416,200904,37722,106147,986654,607442,560667,689572,993885,862932,72642,785815,63680,912372,298111,217040,33090,484668,855572,845054,923943,230212,11719,368592,762066,65275,882967,312789,99465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]