SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002427s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406911 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406911 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666686,731692,916336,4622,70698,1042695,734267,845936,153105,490363,227892,132219,38631,730116,24555,701057,124998,258861,282169,18592,361096,639462,414946,995401,965786,880383,606641,462125,259630,302952,9666,159069,488786,278453,170636,228974,458006,353863,868179,865682,857589,385982,578504,429038,732059,412846,198824,237956,950142,937445,795763,730134,273542,910567,168434,840423,135010,139233,803309,416222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]