SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150412 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150412 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322955,910856,347001,83566,712403,110330,785863,890641,8943,673363,1010592,600788,815026,305839,713119,216593,415336,80906,587830,379860,680027,331330,235895,456389,306780,18990,970423,528918,890418,593579,631918,562163,901029,983816,636725,900149,928134,988013,552398,472034,929240,494067,422661,650105,1031851,2330,252795,225066,565088,663981,491165,278807,1036731,987132,545280,591980,586317,681142,371740,958735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]