SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416968 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416968 [ RunTime:0.002184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768346,200979,496431,890030,958956,469620,478100,178240,884299,366465,590890,134926,140057,723456,252343,564452,996182,587948,755937,305885,608463,16410,70413,407006,419817,601544,882418,737475,795138,717291,249764,948165,497862,491541,825840,598962,515611,682824,838193,508549,743910,363673,958707,854503,341613,241077,740316,697662,23915,164138,1012188,697433,697481,778951,178896,227184,510713,62949,139328,67386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002086s ]