SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016177 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016177 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170394,264015,258593,105844,99982,765917,422029,801980,287050,624176,60512,631061,815870,9630,209964,77335,899304,642378,194739,249929,691069,822796,896097,837385,569132,722252,147389,538379,735910,610202,593138,13683,110261,251783,271370,1017002,690145,210385,945064,194518,518186,799911,728553,1009627,111802,535850,842427,142274,893041,385977,967243,535907,744700,608031,280228,907167,753339,595113,3080,861833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016177 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016177 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]