SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510753 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510753 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271774,734444,117943,460739,691174,376954,866037,602175,955667,515955,959684,719721,103789,1046102,624276,916920,245939,339334,2992,86338,1024137,386519,251185,367809,255616,201178,270975,368846,810956,185830,443630,892726,81535,153653,949877,451317,932732,623617,237708,494116,14302,318460,847999,657835,791514,927104,345494,810978,340672,983136,976112,566669,791755,925283,432949,24097,682812,724148,903456,255435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.031642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]