SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505454 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505454 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83731,13979,667442,112054,286398,914637,124512,42348,917131,999780,140506,409713,271622,851333,1024769,295565,419826,288304,651564,398841,522128,649319,24762,47967,355032,849114,962288,527247,202226,273796,1888,532466,203729,626439,336584,642663,861513,79700,365792,457776,558877,172816,551948,452955,874459,407221,998567,909918,670155,195597,697126,283179,379511,694063,851244,369972,985374,442199,736875,428073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]