SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101710 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101710 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922976,44903,821749,624626,167352,286130,750691,279211,145331,753213,791430,14217,799395,471614,1047567,917967,881690,819740,727784,588321,525150,264448,267635,834373,781697,151801,305362,622740,168916,278073,76826,308100,279566,787587,16660,718703,337163,390076,256828,521445,604456,467131,30112,811592,640855,264983,1024932,378367,334243,408547,643235,737483,116654,459348,938486,366770,44451,1040332,944306,301072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]