SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003558s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 697818 LIMIT 1 [ RunTime:0.004454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 697818 [ RunTime:0.002516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013064,761711,522581,698109,55370,817288,841162,670960,611233,871799,269141,153787,848935,104893,259224,417572,215480,682126,862878,586643,247345,552979,840814,936700,938793,879635,797666,643624,493853,35140,1011206,534098,248351,844746,270754,831734,209097,33626,503495,557359,182870,612577,272136,298764,36687,587443,338786,123880,768878,39963,534177,874830,890497,852187,660024,837555,425000,980450,128358,28196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 697818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 697818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005585s ]