SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394040 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394040 [ RunTime:0.001414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342886,775713,181488,362631,175200,101129,137417,712324,528111,1045960,11194,826701,1004077,961652,414998,813549,453858,327587,75030,456157,676314,235452,297794,157032,647470,181684,853155,543124,1041975,701610,627025,195688,612270,168675,133302,1877,583880,460702,513079,396581,546558,690168,89172,658861,170422,419290,766506,182713,442570,849357,32086,866677,432249,373576,968814,968087,18122,692164,336173,93840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]