SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432070 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432070 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902912,554435,437541,948706,352867,467856,53241,450632,143859,279198,11951,260568,567054,800721,476578,332457,1029035,844426,47666,494115,86077,802114,713068,965491,398390,299412,263107,1027108,612836,35997,178686,922935,84553,96702,125090,956761,719191,919720,717627,793330,567927,90552,230094,254873,444896,675865,783028,694855,165164,498026,251274,166111,799182,340885,954962,131488,657869,484255,9553,12232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000363s ]