SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10368 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10368 [ RunTime:0.004802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97667,845128,626492,904824,593727,732254,55991,676943,172004,812240,441558,664808,362415,104922,129612,723333,671947,118716,748429,680132,774907,447428,439656,779924,271239,558933,268106,801924,393951,57366,599129,613542,831686,913740,552839,955024,352494,551821,260784,807527,98233,241812,875072,165068,556428,781569,472499,941095,153611,326657,745907,287121,710236,312459,643408,359674,881409,242959,218181,244468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]