SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343439 LIMIT 1 [ RunTime:0.001231s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343439 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038140,372525,432009,656420,718649,296696,842788,592001,581866,429742,547559,650688,382694,488213,500587,476915,435456,625607,529882,286339,424604,145183,1019244,1003392,726560,1001187,213372,251009,872477,148823,119329,676699,937076,803914,620803,562572,914379,94413,275181,461804,390375,421327,613959,451500,280804,363128,103389,484895,1034105,1005583,935961,237524,863044,508969,922835,16220,990724,806703,343239,563088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001564s ]