SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472582 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472582 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652098,520220,318577,581513,244071,613435,414095,880101,934545,1023316,752369,492506,868278,68081,636737,448200,1021230,310725,115497,119149,890794,958933,69421,143805,324682,16299,105931,501894,83198,457258,1028141,305404,600559,415609,224504,127934,28924,965313,602366,693322,929938,805331,593012,645015,319842,358481,159606,93390,213758,172021,52989,507794,740376,438414,14144,653911,405285,530922,334701,200085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]