SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284555 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284555 [ RunTime:0.004327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678434,201099,454975,1045110,300513,861563,63877,47419,1000106,219226,230657,297769,584238,618480,333120,168248,853815,870329,395363,730211,117107,713474,1037146,389336,512644,203744,464993,818114,627145,730060,233534,122691,1029610,261631,143894,322897,660831,634989,823351,438860,173537,81279,525175,368131,610940,493012,780823,964813,476643,764958,727133,1047157,943283,681056,740941,385099,154416,52275,612727,854612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284555 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284555 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]