SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 242863 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 242863 [ RunTime:0.002205s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039166,440121,195906,866527,573639,577211,547877,1003994,390530,12496,980120,771043,701601,959704,187416,115999,52860,862597,895775,377608,536616,543440,501446,260894,224356,109902,923011,21443,869353,538247,908114,794757,989083,18935,250069,803808,1625,535463,176882,894064,907824,1024850,751642,55667,861630,153586,885464,114331,254278,135216,446977,98573,403305,32289,215725,271161,774348,45428,485174,118868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 242863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 242863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]