SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 647513 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 647513 [ RunTime:0.002275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408307,512895,728061,441657,325536,786134,889936,432899,228321,551255,324585,520321,533392,643910,577100,341219,361146,615630,824096,938880,444070,369736,461753,460089,979091,420305,824394,860779,511920,406922,466559,93587,650479,558857,519776,438583,163132,410712,759988,261432,209325,281405,381054,735931,916703,592340,905736,1039150,866036,526265,133089,303840,241502,318249,217649,360461,509920,925815,608006,550957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 647513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 647513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]