SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107283 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107283 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651920,427557,213624,704179,23506,295786,477473,918949,714834,517814,561492,190500,558215,740613,1021380,701504,87974,833791,392072,413942,76326,154645,90920,634049,913202,308845,1018196,621848,326222,876827,374433,953111,46885,1015815,39001,698587,570210,483985,684129,828215,611495,279624,11774,143699,995474,938143,946229,401750,977051,838710,894566,357306,788685,335135,303172,442408,187214,225712,614388,513654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]