SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 836108 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 836108 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174816,898048,313482,486015,409032,746033,572121,619421,146602,242879,1046617,489521,838921,1004979,331769,156434,849852,14517,439696,500977,895573,796823,156016,957691,599286,302563,66328,779687,239692,964076,819530,462220,116961,934548,590034,654289,139319,118993,889427,1015288,125608,438892,717960,631571,605948,546994,844828,359814,1020375,185944,722757,68145,718863,596830,781896,606058,97334,1027581,756373,324841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 836108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 836108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]