SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385110 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385110 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215656,101483,818335,212071,298645,194214,693661,252718,911501,578814,204275,472915,663582,133735,521460,1000730,594473,421245,355009,260523,648745,240790,784772,254933,315662,914491,489828,347879,405086,611742,322356,480456,249830,549633,450834,551710,133057,616996,652461,1009680,248696,770287,614730,914057,163150,85407,737519,852234,268021,833187,328762,17125,166361,1009837,735419,895552,486840,463684,500836,989913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]