SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326808 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326808 [ RunTime:0.003407s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771272,1032039,1034641,1001132,42536,633213,724048,682992,686292,966548,321919,79353,836072,45712,516797,775861,943439,763176,57344,528891,538349,368162,307618,1004409,517124,678516,126449,575765,718484,508714,702830,325421,365065,236258,54086,439490,66600,284893,875338,613447,505755,259611,1040210,125086,977467,152572,520632,752868,649876,69207,729245,84347,1007444,713233,176254,380291,983585,612396,806021,436264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000367s ]