SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001774s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505975 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505975 [ RunTime:0.003333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873285,325655,1021432,189015,255868,837015,490989,779515,438869,916683,11805,895595,938679,51340,203303,890987,132935,577955,501102,332837,952247,423893,466740,360033,855592,684189,515872,726783,290965,13712,1020498,849381,584123,851533,933909,669995,266975,105883,885995,883104,494595,654308,942985,476555,960307,167943,757557,15288,42161,919410,546049,957551,458151,246489,262026,686379,719071,840518,838744,852142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]