SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 362207 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 362207 [ RunTime:0.002163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101179,214568,234435,980041,1048662,443301,35657,332434,918996,31202,143860,791033,442154,260698,638023,696950,976848,252423,188878,435440,407421,393033,818056,191132,22392,75425,746837,79650,634251,635482,268100,297702,316655,366290,318181,378184,946912,497700,356896,946614,433124,761714,848738,156704,75329,630672,360123,310793,623814,579342,773491,483604,706725,883409,602127,992225,900861,963666,9461,287894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 362207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 362207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]