SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211011 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211011 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034031,725073,614484,51194,822092,757770,1034141,497806,270177,1037311,536170,938943,916529,848960,344598,1034715,340627,184703,63680,365083,401973,296267,582793,381963,148808,721802,70097,440790,186389,160910,764179,60375,870575,55222,1023701,784990,921502,531471,298177,1034327,735390,245191,772443,938094,666958,536813,637209,250893,889929,482098,666744,1011651,947770,81268,981596,60817,147787,1036058,852737,427631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]