SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201944 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201944 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460054,488988,951377,733066,580609,1003450,300563,339295,349274,527783,1014070,426621,680813,227021,360912,90295,879792,276138,576334,224697,457715,284618,708095,727255,98812,774300,452476,235113,436075,238708,339037,33707,1041724,614951,88854,842363,530706,744621,365896,16519,655043,346959,912424,120775,361124,656589,571768,415896,769502,719097,415261,634330,190437,523936,897404,75324,237081,811581,257340,890263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]